ContributionsMost RecentMost LikesSolutionsInventory batch numbers and information Hi, Do you know if it is possible to put the following information detailed when the purchase product is received ( from order to bill) and when the products are sold. The details are: Batch number Expiry date Manufacturing date Stock receipt date We need to be able to track stock based on “batch number” and that all orders being despatched need to be linked to a batch number. we have product code/item code for the products but now my company would like to incorporate batch numbers into each item/product. i can't find any where that i can put in those 4 information. appreciate your kind help. thank you Purchases Supplier Summary report doesn't show Freight amount and Total and correct Current Balance payable when run in Originating Currency HI, isn't it ridiculous not able to do so? how am i going to generate accurate Purchase Order report? thanks! Re: SOH report per location as per specific date desired. Hi Princess_R Thank you so much for the reply. Appreciated. However what i need to generated inventory report as per specific date and location. For eg. today is 28/3/24, i want to have the backdated SOH per 31/1/24 with locations any luck? :) SOH report per location as per specific date desired. Hello, need help here :) my company that i am working for has various WH locations. It appears that I'm unable to locate a report within MYOB AccountRight to produce an inventory report for each location as of a specific desired date. anyone here is able to do so ? Thanks! Annual leave Hi, i have been struggling about AL & LSL that my company recently started to accrue staff AL & LSL do i set up correctly of this staff who has 52.01 hours AL ( my boss's excel sheet) accrued by 30/6/23 and i set it on opening balance for FY23/24? ( see attached pic) On EB: 114.03 hours accrued 91.2 hours taken or should i put 29.18 on the balance adjustment instead of 52.01? is it correct the carry over shows 22.83 on employee card? ( see pic) and ytd 12.67 but why total become 74.84 when theoritically should be 52.01 + 12.67 = 64.68 when i ran for EB July23. pls help. thx any MYOB consultant that we can engage to get the AL & LSL set up correctly in our MYOB? we have been searching but seems no response. Re: inventory value reconciliation vs BS Hi Mike, yes i managed to export out the item list i dont see anything wrong. all item set up under the correct inventory asset account. what's the possibility reason for this out of balance and i am lost for days how to fix this.. but we have few items that ' i inventory item' are not ticked as we dont keep this item in our WH, only get from supplier and resell it immediately for export. ( it was long time set up by my predecessor) TMO, those items need to be ticked too right? cause recently we came accross that those items are not generated Cost of Sales so it causes my analaysis item report margin is 100% for those items. Re: inventory value reconciliation vs BS Hi Mike, we use only 1 inventory asset account yes we do purchases and receive items in our various WH locations but we receive items but convert the purchase order in MYOB to bill when the goods arrived. How to check the item setup? from item list summary report and export to excel? my GL for inventory asset account = BS TIA Re: inventory value reconciliation vs BS Thanks for the swift response, Mike i ran per 30/6/23 the delta is 27,568.29 which the stock value greater than the GL/BS i ran per 30/5/23 the delta is -3,355.29 which GL/BS is greater than stock value in fact i ran each month throughout FY22/23 , each month is Out of balance What could possibility happened? someone i iknew who uses MYOB for many years told me , hers also always Out of Balance, Therefore she doesnt rely on this inventory value reconciliation report. and how to rectify this for our EOFY? i checked the ff FY21/22 and FY20/21 too : as of 30/6/22 the out of balance only -$0.33 but as of 30/6/21 the out of balance was $45,721.20 TIA inventory value reconciliation vs BS Hi, does the stock on hand shown on BS must have same figure shown on inventory value reconciliation report? if not, which inventory report that i can generate to match my BS inventory figure ? also despite checked all entries are correct, my inventory value recon shows out of balance though. TIA for the help. Profit Margin report I am looking for a report that will help to calculate the overall profit margin on each customer. Any one has tips to share please? thanks!