Spreadsheet: 731274d1620259849-formula-to-populate-orders-master-excel-forum
Sheet: Purchases

Purchases By Period
Visually Group By | Compare Values By | Summarise By | Show Values | Reporting Units
None | Month |  | Quantity (Equivalent Unit) | [NAME]
Item Code | Item Description | Order Number | [NAME] | Supplier | Order Category # [NAME] | Planned Receival Location | Equivalent UOM | Oct (2020) | Nov (2020) | Dec (2020) | Jan (2021) | Feb (2021) | Mar (2021) | Apr (2021) | May (2021) | Jul (2021) | Total
AU-100098 | a | 60189 | a | a | 13-Jun | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100098 | b | 60269 | b | b | TBC | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100098 | c | 60271 | c | c | TBC | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100104 | d | 60336 | d | d | N | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100117 | a | 60315 | a | a | 11 May | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100190 | b | 60285 | b | b | 24-Apr | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100225 | c | 60273 | c | c | 1-Jun | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100225 | d | 60273 | d | d | 1-Jun | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100235 | a | 60312 | a | a | 30-May | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100247 | b | 60315 | b | b | 11 May | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100267 | c | 60334 | c | c | TBC | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100268 | d | 60335 | d | d | TBC | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AU-100303 | a | 60317 | a | a | 18-Jun | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Freight | b | 60285 | b | b | 24-Apr | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Freight | c | 60285 | c | c | 24-Apr | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Freight | d | 60251 | d | d | (not set) | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100003 | a | 60326 | a | a | 30-Apr | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100004 | b | 60283 | b | b | 28-May | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100020 | c | 60213 | c | c | TBC | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100021 | d | 60213 | d | d | TBC | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100026 | a | 60290 | a | a | (not set) | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100026 | b | 60333 | b | b | (not set) | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100026 | c | 60332 | c | c | (not set) | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100028 | d | 60310 | d | d | TBC | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100031 | a | 60323 | a | a | 24-May | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100034 | b | 60306 | b | b | 11-May | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100038 | c | 60320 | c | c | TBC | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100047 | d | 60251 | d | d | (not set) | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100052 | a | 60283 | a | a | 28-May | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100067 | b | 60276 | b | b | 30-Apr | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100067 | c | 60263 | c | c | N | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100067 | d | 60276 | d | d | 30-Apr | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100067 | a | 60256 | a | a | 18-Jun | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100070 | b | 60318 | b | b | 2-Apr | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100070 | c | 60319 | c | c | 7/5 | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100077 | d | 60283 | d | d | 28-May | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100079 | a | 60321 | a | a | TBC | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | b | 60323 | b | b | 24-May | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100090 | c | 60326 | c | c | 30-Apr | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100187 | d | 60251 | d | d | (not set) | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100196 | a | 60213 | a | a | TBC | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100213 | b | 60325 | b | b | 28-May | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100215 | c | 60251 | c | c | (not set) | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100221 | d | 60306 | d | d | 11-May | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100224 | a | 60263 | a | a | N | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100224 | b | 60276 | b | b | 30-Apr | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100224 | c | 60256 | c | c | 18-Jun | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100224 | d | 60265 | d | d | N | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100224 | a | 60267 | a | a | N | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100224 | b | 60221 | b | b | 15-Jun | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100225 | c | 60276 | c | c | 30-Apr | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100225 | d | 60256 | d | d | 18-Jun | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100225 | a | 60256 | a | a | 18-Jun | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100225 | b | 60263 | b | b | N | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100225 | c | 60223 | c | c | TBC | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100225 | d | 60255 | d | d | waiting on boat | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100225 | a | 60257 | a | a | TBC | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100225 | b | 60258 | b | b | 18-Jun | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100225 | c | 60259 | c | c | N | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100225 | d | 60261 | d | d | N | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100225 | a | 60296 | a | a | N | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100229 | b | 60324 | b | b | (not set) | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | c | 60287 | c | c | 2-May | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | d | 60221 | d | d | 15-Jun | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | a | 60265 | a | a | N | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | b | 60267 | b | b | N | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100254 | c | 60276 | c | c | 30-Apr | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100306 | d | 60276 | d | d | 30-Apr | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100306 | a | 60221 | a | a | 15-Jun | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100307 | b | 60316 | b | b | (not set) | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100390 | c | 60265 | c | c | N | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100390 | d | 60267 | d | d | N | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100390 | a | 60221 | a | a | 15-Jun | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NZ-100403 | b | 60329 | b | b | [NAME] | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pallets | c | 60287 | c | c | 2-May | z | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0