Looking for help to set up 2 different sheets in a spreadsheet (maybe best way to do it?).
Context:
It is for an orchard, and I want to do the following:
1) Keep track of total quantities of fruit sent to a pack house, which has a corresponding 'work order number' (and record some other pack out related information)
2) Record information about invoices/payments received back from the pack house in respect of the 'work order number'
The difficulty is that although the pack house provides a single 'work order number' for the pack out information, when it submits the invoice for the payment, it groups multiple 'work order numbers' together and there is no break now in the invoice about which work order is paying what. For example, might list that the invoice is for 3 different working order numbers, and give the overall price paid for the total of them all.
Secondly, the pack house provides 3 different types of invoice payments:
1) Domestic
2) Export I
3) Export F
So will get an invoice relating to a domestic payment for one working order, then will a few months latter get another invoice corresponding to the same working order for a different type of payment (e.g., Export I).
I need some way keeping track of what working orders have been paid, and for what type of payment (domestic, export I, or export F).
Would be enough to just have some way of filling invoice details into a spreadsheet, and then somehow having the spreadsheet with the packout information saying Yes or No to a certain payment type.
Been going in circles trying to figure this out. Anyone have any ideas?
Bookmarks