Sage ACCPAC: Apply Credit Note to Line Items, not Document 1

[Ho3n3r]

First off, I apologise for my absolute apparent noobness on ACCPAC. I have started a job requiring ACCPAC programming knowledge, as well as practical knowledge of it.

The current problem I have is that a system written in VB.NET applies Credit Notes to Invoices for Debit Order customers who have cancelled memberships before all 12 periods of the relevant fiscal year was, or at least that is how I understand it.

Q1:
Now, it has to be modified that that Credit Note is applied to each line item on the relevant invoice by percentage still left be, so if the invoices were only 40% paid up before cancellation, 60% has to be paid back to the company who paid on behalf of the members, but if the original invoice for example was R1000 for line item A, R500 for B and R500 for C, R600 has to be paid back for A, R300 for B and R300 for C. Currently R1200 is paid back and applied to the invoice.

Q2:
Then we have another issue, which I am sure is easy to fix but I am not getting how: when applying the credit note here, the original invoice amount and the outstanding amount do not match on debit order members.
How would I correct that both programmatically and via ACCPAC?

Thanks for anyone's help, as this is making me feel like a deer in headlights. I really wish I could find a comprehensive programming manual for ACCPAC.

 

[ettienne]

Q1: What's the question hey?
Q2: You're new to accounting hey? If an invoice has been partially paid then the outstanding amount is going to be less than the original amount.
There is no comprehensive programming manual, so stop searching.

You need to be clear with your questions.

 

[Ho3n3r]

Thanks for the reply Ettienne.

Yes, I am new to ACCPAC and accounting, as stated in my first post.

Q1 I am asking how to apply the credit note to the line items instead of the invoice itself.

Thanks once again.

 

[Jay Converse]

You don't, that's not how accounting works.

 

[ettienne]

Credit notes are applied to invoices.
Are you doing AR or OE credit notes?

 

[Ho3n3r]

@Ettienne: It is Accounts Receivable. OK so do I tell the client that it is not possible, and that it should not happen at all, ever? Thank you.

 

[Ho3n3r]

See, that is why I applied here, because you nice guys know something about ACCPAC/Accounting and I don't, but it seems easy to learn, there's just so many things I need to actually learn somewhere.

 

[Ho3n3r]

OK let me rephrase - I need to apply the remaining amount that was not paid - 60% in the case above - to the individual line items of the original invoice, but in a new credit note. Is this possible?

 

[ettienne]

Yes to the last post - well not exactly as you put it but partially correct. You create a new credit note applied to the original invoice. The detail lines of the credit note will have the breakdown in 3 lines as you described earlier - but the detail lines are not, or rather cannot be applied to anything, they are just there. The main thing is that the credit note is applied to the invoice - that's all that matters in terms of applying something. Enter a credit note or have someone show you how to enter the CN and you will see what I mean. Don't overthink it, it is a simple credit note transaction.

 

[Ho3n3r]

Thanks Ettienne. That makes sense. I think I am making it too complicated.

Cheers.