The "Amount" column in the Daily Sales Invoice report needs to be populated INVERSE of what you would expect.
If the Sales Invoice was a sale, the numbers reported here should be NEGATIVE numbers. So each line item would need to be multiplied by -1.
If the Sales Invoice was for a return, the numbers should be reported as POSITIVE numbers. So again each line item would need to be multiplied by -1 to get the correct data for the column.
Everything else about how the column works appears to be correct. So is each line item is multiplied by (-1) before being entered into the column this will also allow for Sales Invoices that may have a mix of returns and sold items on the same invoice number.
Just make sure your solution does not error if a line item is zero amount!
I realize this is the opposite of what might seem normal, but it is required for the external accounting program. Thank you.
The "Amount" column in the Daily Sales Invoice report needs to be populated INVERSE of what you would expect.
If the Sales Invoice was a sale, the numbers reported here should be NEGATIVE numbers. So each line item would need to be multiplied by -1.
If the Sales Invoice was for a return, the numbers should be reported as POSITIVE numbers. So again each line item would need to be multiplied by -1 to get the correct data for the column.
Everything else about how the column works appears to be correct. So is each line item is multiplied by (-1) before being entered into the column this will also allow for Sales Invoices that may have a mix of returns and sold items on the same invoice number.
Just make sure your solution does not error if a line item is zero amount!
I realize this is the opposite of what might seem normal, but it is required for the external accounting program. Thank you.