You’re offline. This is a read only version of the page.
5
Hello,
I am trying to adjust an item's quantity on hand by creating and posting an item transaction with type 'adjustment'. I can successfully create and post a transaction through the GP user interface by going to the 'Inventory' tab and selecting 'Transaction Entry', then entering the information and clicking 'Post'. I want to replicate this in a C# application using eConnect, but I've only been able to create an unposted item transaction, which doesn't change quantity on hand and would require someone to post it through GP.
The eConnect schema for the header object I am sending: taIVTransactionHeaderInsert
The eConnect schema for the line object I am sending: taIVTransactionLineInsert
The eConnect schema for the transaction type: IVInventoryTransactionType
The header has fields for a batch number and posted user/date. I've tried leaving out the batch number since I want a posted transaction, but that field is required. I've tried setting the posted user/date, but the date is not set and the transaction does not get posted. I've been unable to locate any eConnect documentation about this, or any other references to this issue online. If anyone could help with this or point me in some direction to get help, it would be much appreciated.
That is not eConnect's job. eConnect's job is to bring transactions into GP as if you were entering them manually. Then the user prints the edit list and posts. Now since there is no batching of bank transactions they will post automatically. Your company may have a policy where the user who enters the transactions is not the same one that posts them. This is simply for checks and balances. The auto post third party products came about to address these requests and help when there is a large number of transactions.
You are trying to do something that is not possible. As you noted the schema for taIVTransactionHeaderInsert you see that the batch number is a required field. The transactions coming in from eConnect must go into a batch and then the batch is posted using GP. There is no way to import an online transaction using eConnect. There are products called SmartPost and BatchMaster that can post batches automatically.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (