ContributionsMost RecentMost LikesSolutionsRe: SOH report per location as per specific date desired. HiPrincess_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 1inventory 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! to write off shortpayment a purchase invoice my record has oustanding AP of a purchase invoice from a vendor. But the vendor doesnt acknowledge it in their record. How to write off in my MYOB record this balance purchase invoice. Thx COGS & Sales Invoice Hi, will generating the sales invoice prior to have the correct COGS in the purchase entry affect / screw up the reporting? Scenario of my issue is , i have not received the purchase invoice of repacking cost of my products that need to be added into the product cost after it's being repacked. but i need to urgently generate the sales invoice for customer. can i generate the sales invoice then make adjustment on the purchase value later on ? TIA Kind Regards,