Dynamics GP Sales Invoice Update Account Reconciliation

I’m working with Microsoft gp dynamics, I need to update a sales invoce line unit price because of bank reconciliation, when I do it using the updateSalesInvoce method, it updates the unit price, but the the quantity is set to 0, when it was -1, every time I try to change the quantity I get the error EconnectError-2262:  “Modified quantity cannot be less than the quantity already transferred”, any help would be appreciated.
LVL 1
elburgundi666Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Steve EndowMicrosoft MVP - Dynamics GPCommented:
Hi,

I'm not understanding the issue you are having or what you are trying to accomplish.

Can you restate your issue with a little more detail or background explanation?

For instance, what does a sales invoice line unit price have to do with bank reconciliation?

Are you trying to change the unit price of a posted or unposted invoice?

You mention "updateSalesInvoce method".  What are you using to call this method?  Is this an eConnect integration? Web Services?  IM?  Custom integration?

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional



0
elburgundi666Author Commented:
The bank reconciliation is the cause, what we are trying to achieve is to change the unit price because the bank charged few cents less than it was registered in GP, the status of the invoice is unknown for me I’m a newie about GP, the updateSalesInvoce is a DynamicsGP method  called through DynamicsGPService.asmx.

Thanks.
0
Steve EndowMicrosoft MVP - Dynamics GPCommented:
Hi,

Something doesn't sound quite right.

I still don't fully understand the issue you are experiencing, but my interpreation is that you are trying to resolve the issue in a way that is not an accounting best practice.  

If a sales invoice has been posted in GP, and it is valid, you do not want to update it directly.  Ever.

If there is an issue with the bank rec, such as some type of small discrepancy, there are several ways of dealing with that properly through bank rec adjustments, bank transactions, or if the issue really does need to be corrected at the customer account level, through Receivables Management transactions (i.e. debit or credit memo or perhaps a write off).

Bank reconciliations should only affect cash, not revenue or receivables (invoices), so that is why I'm having a hard time understanding why you need to update a sales invoice due to a bank rec.  A bank rec involves cash receipts, or cash disbursements.  So if a bank received a customer deposit and recorded it a few cents less than what you have in GP, you can enter an adjustment in the banking module to deal with it.  You do not want to affect the invoice that was sent to the customer.

If you are trying to update an unposted sales invoice, let me know and I'll review the issue again in that context.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional



0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.