web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How do I set the batch...
Microsoft Dynamics GP (Archived)

How do I set the batch GLPOSTDT with Integration Manager Receivables Transaction?

(0) ShareShare
ReportReport
Posted on by Steve Burner 35

I'm hoping someone can help me figure out how to set the GLPOSTDT in the batch master table (SY00500) from an Integration Manager package setup with a "receivables transaction" destination.

My current integration has a mapping to the field "Posting Date", but this does not appear to be updating GLPOSTDT. Once the integration is run and you go into Receivables Batches to view it, it is defaulted to the current date. There are other fields that do find their way to SY00500, like "Batch ID" which goes to BACHNUMB.

Is there another field I am not seeing in the destination properties that will map to GLPOSTDT? Or is it just not possible to have the posting date set from an integration?

Thanks

*This post is locked for comments

I have the same question (0)
  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    Batches imported always have today as the GL Post Date in the batch.  A couple of options:

     1.  Manually change the date prior to posting

    2.  Change posting to use the transaction date rather than the Batch Date for posting.

    3.  Import the transactions on the day you want them posted.

     

  • Konrad B Profile Picture
    Konrad B 45 on at

    Hi

    I have written some VBScript in Integration Manager to do this - Option 4 ;)

    Here it is:

    'Make the Posting Date in the Destination point to the field you want to use for the Batch Posting Date
    'Add this script to the AFTER DOCUMENT script in Integration Manager

    'Set the Database ID in the variable below for use in the Connection String
    'Set the login and password in the variables below for use in the Connection String
    'Ensure the login used has update rights on SY00500 - eg. grant update on sy00500 to frx

    'Change these values to your setup:
    sDatabaseID = "TWO"
    sLogin = "frx"
    sPassword = "frx"

    sDate = DestinationFields("Posting Date")
    sDate = CStr(Year(sDate)) & "-" &  _
      Mid("00", 1, 2 - Len(CStr(Month(sDate)))) & CStr(Month(sDate)) & "-" & _
      Mid("00", 1, 2 - Len(CStr(Day(sDate)))) & CStr(Day(sDate))

    'Create a new connection

    Set pConnection = CreateObject("ADODB.Connection")

    'Open the connection to the database

    Call pConnection.Open(sDatabaseID, "frx", "frx")

    'Build a string containing your SQL Statement

    sSQL = "Update " & sDatabaseID & "..SY00500 set GLPOSTDT = '"
    sSQL = sSQL & sDate & "' " 
    sSQL = sSQL & "where BACHNUMB = '" & DestinationFields("Batch ID") & "'"
    sSQL = sSQL & "and BCHSOURC='RM_Sales'"

    'Execute the SQL statement

    Call pConnection.Execute(sSQL)

    'Close connection when finished

    Call pConnection.Close
     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans