CornucopiaApoth
Contributing User
Joined 5 months ago
User Profile
User Widgets
Contributions
Inventory Transactions
Hi MYOB Community Recently, I connected my square mobile payments to MYOB. I has successfully generated invoices and applied the sales to the appropriate sales account. I want to check if my Square payments are adjusting the inventory levels of the product items. I'm sure that I have set it up correctly however I just want to check the dates as to when the inventory for each item was adjusted. I found the Inventory report, but that only shows the total sales for a period per product item. I want a more detailed list of the dates that the units were sold. Is this possible? best regards Jason254Views0likes1CommentRe: Inventory levels fail to update for bank feed entries
That's a great idea, Mike.It took a human to think of that!! Plus it's an easy way to analyse and drill down on cash sales if they are invoiced, I suspect. I'll give that a go now. Will leave this topic open for a bit in case I have another question. cheers Jason503Views0likes3CommentsRe: Inventory levels fail to update for bank feed entries
Hi Mike Had a good read of the documents that you linked. I have set up Perpetual Inventory as per the document's outline. All of my inventory items are properly assigned to the correct linked accounts. The documentation only covers inventory level updates for supplier bills and customer invoices, which are already working perfectly. I can't find any information about what to do for cash sales on either the bank feed line items or even the undeposited funds cash sales entries. So, my guess is that I continue to allocate the appropriate income account to the cash sales line entries as per my screen shot then manually make an inventory adjustment. Wish it could be automatic but this appears to be the only work around. Even ChatGPT doesn't have a better answer! LOL Cheers Jason526Views0likes5CommentsInventory levels fail to update for bank feed entries
Hi MYOB Community For some reason, when I allocate a cash deposit in my bank feed to various products, the inventory fails to update. The levels update perfectly when I generate invoices or procduct supplier bills but not when I try to allocate thec ash entries and apply a quantity to the line item. For example, our Restorative Balm is recorded as an Inventory item as follows: Full Spectrum Hemp Balm with the item ID as HBPB-60ML The Asset account that has been created to correspond with the Inventory Item is as follows: 1-1410 HBPB-60ML - FS Hemp Balm - 60ML - Pure Blend Conversely, the Income account that has been created to correspond with the Inventory Item is as follows: 4-2110 HBPB-60ML - FS Hemp Balm - Pure Blend - 60mL And, finally, the Cost of Sales account that has been created to correspond with the Inventory Item is as follows: 5-1110 HBPB-60ML - FS Hemp Balm - Pure Blend - 60mL When I select a product from the income account list, the inventory doesn't update. I have included a screenshot of the bank feed to see if I have done anything incorrectly. Any help would be greatly appreciated. regrds JasonSolved532Views0likes8CommentsInvoice closed but still showing as unallocated
Hi guys Since I started using MYOB four months ago, invoice payments have been automatically allocated. That is until December where the invoice shows as being paid and allocated but my bank feed says that the payment is unallocated. This effects three invoices. Firstly, why has this happended and secondly, how can I rectify the situation. Best regards Jason190Views0likes1Comment