Using Sage BOI, trying to write an AR_CashReceiptsDetail will fail!
I am trying to make a tool to help AR out. We have customers that may pay for one to many other customers. AR is simply given a check with an amount and has to figure out how to apply it. They have to look up many customers and find open invoices and this takes hours. I have a GUI that shows the main customer and all of their customers with open invoices. The check amount is entered. Each invoice can be paid off but if there is a remainder it goes to OVPMT of the main customer instead of an invoice from one of 'their' customers.
So far I can make cash deposits all day (later I will make credit card deposits) and it looks like I can mostly make a cash receipt header but not sure if I get the cash receipt details right as it fails when I try to write with: "This distribution is out of balance. Do you want to delete the distribution?" just like I see on Sage's GUI. I am either doing something wrong, or I do not know how to answer that question: is there a function to address the question and tell BOI 'NO'?
I want to make one deposit and use it for many transactions against other accounts and also perhaps place any remainder back into the originator of that deposit as well... so I need to make many transactions against the same deposit. Ultimately it will zero out, my GUI wont let the AR person continue unless all is accounted for (and any remainder goes to the check originator anyway)
Sorry for the long post but I err on too much info instead of too little (he said hopefully). C# and com
I will post the code context where I have the issue but here is the actual line it fails on
retVal = pvxNoParam(AR_Header_Bus, "WRITE", out sLastErrorMsg); //!!ERROR HERE!!! This distribution is out of balance. Do you want to delete the distribution?