Jump to content

Reporting negative nett item sales

Recommended Posts

The item sales report only picks up the positive invoice data. I also raise credit notes based on items, but the overall Item Sales Report and Item Sales by Customer does not record these as negative sales. Is there a work around? 

Link to post
Share on other sites

Hello Tom,

The program will count the credit notes as credit notes, and not as negative amounts on sales reports.  That information is available when you run a customer statement. You can do that in Express Accounts > View > Customers, select the customer you want to check, click on Statements and it will show you all the outstanding invoices, and credits for that particular customer.

Link to post
Share on other sites
  • 1 month later...

Does not answer my problem - I need to know the nett transfers of the stock item, not just the dollar value. If the program accepted negative quantities in the invoices then these would show in the item sales history. Sounds like a small code change to allow negative amounts as valid entries????

Also, this makes life hard as I supply on consignment and bill customers their nett sales - so an invoice for a months sales might include both positive ( ie: outgoing ) sales and negative sales ( ie nett returns ) and at the moment I can only handle this as one invoice and one dollar value only credit note.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...