Advanced Sale Invoicing & Receiving advice?

started a topic over 1 year ago

We often find ourselves in this situation and are looking for advice. Most of our purchases are invoiced after being shipped. So our warehouse team check the stock in and the invoice is added later by accounts. However, in an advanced sale, each Invoicing & Receiving line must all tally up. So if you received x10 the invoice needs to have x10 on it. However, for example(and to keep it simple), we often receive x10 however the supplier sends two invoices for x5 + x5. BUT you cannot add more than one invoice to an I&R line. We cannot undo the receiving as the stock is already sold. So our only option is to not use the invoice on the line with the receive, then create two new I&R lines for each invoice. This then creates problems. These additional lines show up as waiting for stock. The first line is flagged as not invoiced. AND the item costs for cogs /margin etc is not pulled through. 

Any advice is appreciated.

2 people have this question
  • Any advice on this? What are other people doing? We can't be the only people struggling with this?

  • An advance payment is a type of payment that is made before a service has been rendered. With advance billing, invoices are sent to clients before the project has been completed. Advance payments can be a deposit, partial payment, or full lump sum. For example, progress payments—partial payment for work that’s been completed so far—can be a type of advance payment.


    Apps4Rent | O365CloudExperts | CloudDesktopOnline

  • We too suffer with this problem Liam.

    The ideal solution would be to allow multiple invoices per Invoice & Receiving block. 

    Currently we have found no way of getting around this problem as whatever solution we try there is always a problem (incorrect COGS, incorrect posting to Xero, etc etc.).

    We may have to move systems as previously we were on SAP which handled this situation fine. 

    Between this and not being able to assign COGS to non-inventory products we are struggling greatly with Dear. 

  • A sort of payment paid before a service is given is known as an advance payment. Clients are issued bills before the job is finished via advance billing. A deposit, a partial payment, or a complete lump sum payment are all examples of advance payments. Progress payments, for example, are a sort of advance payment since they are partly payment for work that has already been accomplished. slope game

  •  If anyone can find a solution to this, I will be happy.  @diane

Login or Signup to post a comment

2 people have this question
Log in or Sign up to post a comment