Skip to main content
Question

Posting Analysis Transferred but no Voucher Generated


Forum|alt.badge.img+9
  • Sidekick (Customer)
  • 29 replies

Good Morning, 

 

We are reviewing our Distribution and Manufacturing Postings Analysis Screen and noticed that we have a transaction that is transferred (Status Code 3) but no voucher was generated.  It looks like the posting controls are setup correctly as we have no errors (M1 - Inventory & M5 - Receipt Without Purchase Order) showing on this transaction.  This is a first time occurrence from the Distribution side for us because we usually clear errors and they push through as desired.

 

Any help on this would be great as this is going to affect Month End Close.

 

We are currently on Apps 10 Update 20 in IFS.

 

Thanks

9 replies

Forum|alt.badge.img+3
  • Do Gooder (Partner)
  • 16 replies
  • November 3, 2023

Check the GL vouchers. Maybe you have a scheduled Update GL vouchers database task which has moved the voucher to GL already. I had a similar question from a user about disappearing vouchers. Check the voucher number column in the postings analysis and then try to find that MPL voucher in the accounting rules and GL. The voucher number is saved on the posting rows at the transfer.

I am assuming that the users are connected to the authority class which allows them to see voucher rows on these two accounts used for M1 and M5.  


Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 29 replies
  • November 3, 2023

@piswpl here is the interesting thing, we uploaded 120 records the same way at the same time.  This is the only one that fell out of the group.  Its super strange and we don’t know why.

 

I dont have a voucher number in the posting analysis screen at all, it never generated.


Forum|alt.badge.img+3
  • Do Gooder (Partner)
  • 16 replies
  • November 3, 2023

Could you post the screenshot of the records with the posting status, posting value and voucher type and number at the same time? Also, could you post the screenshots of the inventory transaction details (all three tabs).

 


Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 29 replies
  • November 3, 2023

@piswpl See attached.


Forum|alt.badge.img+3
  • Do Gooder (Partner)
  • 16 replies
  • November 3, 2023

That’s interesting. I have not seen such case in 16 years. How was this manual receipt created - in IFS or by any SQL scripts or customized logic by chance?


Forum|alt.badge.img+3
  • Do Gooder (Partner)
  • 16 replies
  • November 3, 2023

..as the user who created the transaction is IFSAPP...


Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 29 replies
  • November 3, 2023

It was done via a migration tool with our Admin login (IFSAPP).


Forum|alt.badge.img+3
  • Do Gooder (Partner)
  • 16 replies
  • November 3, 2023

Now you may have your reason. Hard to say anything without jumping into details of that migration. I doubt you will ever achieve the same issue creating manual receipts manually. 


Forum|alt.badge.img+9

I agree with @piswpl.  Can you see any difference between that transaction and the other 119 in the migration file or in the inventory transaction detail in IFS (other than lack of voucher)?  Did you notice if the rest were in a status of ‘2’ after migration, before posting? (I’m assuming they were or they wouldn’t have transferred to the GL properly)


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings