inventory transfer double posted

(0) Share

Report

Posted on by hendy

257

really needs help from microsoft for inventory transfer posting process. our customer entry an iv trsfr document with 2 lines and save it. if we check in iv10001 we can see that doc has lnitmseq value 16384 and 32768. but after the posting process, in iv30300 we discover the lnitmseq value are 16384, 16385, 32768 and 32769. the doc become doubled. Also in table iv10201 and iv10200. we also check in audittrail table. the audittrail record that the posting process has post lnitmseq 16384 and 32768 but it. re-post again those 2 lines, and the audittrail has 2 more record, those are 16385 and 32769. this happens very often. can. anybody help me? when our customer complain about this, I have to fix this doc by tsql. this is very annoying.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Community Member on at

Like (0)

Report

RE: inventory transfer double posted

Hi, I am also facing the same problem with one of my customer .. after posting purchase receipt, items are duplicating the inventory in IV30300 / IV30301 / IV10200. tables.. did you solve the above issue ? please share...

Regards / Biju

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: inventory transfer double posted

Hendy, can you try running checklinks to see whether it solves the issue?

Was this reply helpful? Yes No
Justin Thorp 2,265 on at

Like (0)

Report

RE: inventory transfer double posted

Hi,

I'd recommend seeing what addon's/customizations you have installed, and identify if they are causing the issue.

Also, have you identified any pattern as to when this happens (certain items, workstations, users, companies, etc...).

Thanks,

Justin

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: inventory transfer double posted

Hi Justin.. Thanks.. I am working on it to identify the cause.. seems this issue is not happening at all the time.. some times only.. today I tried to post some batches..its posted fine without any issue.. Btb, no add-on / customization installed in the client.

Was this reply helpful? Yes No
Suggested answer

Romryan on at

Like (0)

Report

RE: inventory transfer double posted

Does your environment have frequent power surge?.

Is not work connectivity strong and constant?.

You can check you client computer specifications whether they comply with GP Microsoft requirements.

RomRyan

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

RE: inventory transfer double posted

Question for you related to dates? IS there a chance the dates the user is entering cross into or out of 'closed' fiscal periods?

If so, is it possible that the system is trying to update the tables for the correct fiscal periods?

Let us know.

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

RE: inventory transfer double posted

Biju, one question or thing to watch here is 'who' is posting. Watch to see if the error happens when a specific user or machine posts. If it is user look at user security to see if there are differences.

If it is machine - look at the configuration of the dates in Regional Setting.

Just doing a bit of brainstorming to see if anything helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: inventory transfer double posted

Hi Bill

Thanks.. I checked the regional settings of the local computer , seems its fine.. also fiscal periods, all fiscal periods are open, please note, this issue not happening all time.. sometime only.. The person who is posting the transactions, have full access in purchase and inventory posting..I am attaching a screenshot generated from the GP SQL server for a particular document..

Regards / Biju

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

RE: inventory transfer double posted

Biju,

There was no screenshot. You have to use rich formatting and then insert the file to get a screenshot included in your post.

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: inventory transfer double posted

Hi Leslie , Since this forum is not allowing me to post more than 64KB pic size, its not possible at all to upload this screenshot here , I have send the screenshot to your email for your reference. Please let me know, if you need any further clarifications, btb, this transactions are not imported, its entered by the user.

Thanks
Biju

Was this reply helpful? Yes No