Skip to main content
Solved

Error in Transfer of Inventory Transaction History

  • February 16, 2021
  • 4 replies
  • 633 views
ProThushA
Do Gooder (Partner)
Forum|alt.badge.img+7

I got the following error while Transfering Inventory Transaction History to finance. 

Error - “The user group AC is not connected to any period with the date 29-FEB-20 in Company xxxx”

Function - Mpccom_Accounting_API.Transfer_To_Finance

I checked all the basic setup such as Users per user group, User groups per period etc. and it was ok.

Then I selected all the Inventory Transactions for 29-FEB-20 and change the Date applied to 28-FEB-20 and I got the following error. 

"No Period exists for the date 28-FEB-20 in company xxxx.

Any valid reason?

When we check the periods it looks like below and ideally it should ends with 29-02-2020

 

Best answer by Adam Bereda

It seems your accounting calendar was wrong, FeB 2020 had 29 days. I am not sure if you can modify dates of accounting period from front-end if transactions exists already in this period. 

    This topic has been closed for replies.

    4 replies

    Mohamed Infaz
    Hero (Employee)
    Forum|alt.badge.img+10
    • Mohamed Infaz
    • Hero (Employee)
    • 158 replies
    • February 16, 2021

    Hi ProThusha,

    Did you check the statistic periods? I am not sure whether a mismatch between static dates could cause this. Else post the Pl/SQL stack trace to analyze the error, if nothing helps it is better to put a case to investigate the issue.

    Cheers, Infaz.
    A
    Hero (Customer)
    Forum|alt.badge.img+16
    • Adam Bereda
    • Hero (Customer)
    • 735 replies
    • Answer
    • February 19, 2021

    It seems your accounting calendar was wrong, FeB 2020 had 29 days. I am not sure if you can modify dates of accounting period from front-end if transactions exists already in this period. 

    Regards, Adam
    M
    Hero (Partner)
    Forum|alt.badge.img+11
    • malik.sally
    • Hero (Partner)
    • 232 replies
    • February 20, 2021

    Please check another thread that I tagged you in with statistical periods. Seems the only way out is a data repair.

    ProThushA
    Do Gooder (Partner)
    Forum|alt.badge.img+7
    • ProThushA
    • Author
    • Do Gooder (Partner)
    • 24 replies
    • February 20, 2021

    You are correct. I had to do it backend. I don’t know how Feb 28th 2020 is created. System should validate the sequential calendar dates. Anyway it has been solved now, Thanks every one. 

    Terms & ConditionsCookie settingsAccessibility statement