Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Financial Management
Lawson S3 Financials
APDISTRIB Entry/Create Date?
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Kyle P.
Past 24 Hours:
1
Prev. 24 Hours:
0
Overall:
5177
People Online:
Visitors:
282
Members:
0
Total:
282
Online Now:
New Topics
Lawson S3 Procurement
Adding Std Comments to all PO's
9/17/2024 7:06 PM
Does anyone know of a way to get trailing comments
Lawson S3 Procurement
Missing po info
9/4/2024 3:34 PM
We are experiencing an issue where freight account
Lawson S3 Procurement
We need to charge multiple items to 1 dept no mattter who orders the items. Our POs are out of company 1000 and cost centers are set up in company 1300. Does anyone else have this issue and have a way around it?
8/16/2024 1:55 PM
We have 3 items that need to be charged to the lab
Infor CloudSuite
Dbimport - only importing 1st record of file
8/13/2024 3:51 PM
In FSM Cloudsuite, I've got a file containing
Lawson S3 Procurement
How does everyone charge an item to 1 dept no matter who orders the item?
8/12/2024 6:20 PM
We have 3 items that need to be charged to the lab
IPA/ProcessFlow
WFWORKUNIT table, WF-STATUS field value set
7/25/2024 8:51 PM
documentation I can find has values for this field
Lawson S3 HR/Payroll/Benefits
Benefit change/termination rules
7/23/2024 2:22 PM
Can old benefit change/termination rules be delete
IPA/ProcessFlow
this.bean is null
7/19/2024 5:42 PM
Getting this error when my IPA gets to the second
IPA/ProcessFlow
Converting UTC Date to EST Date using Javascript
7/16/2024 2:53 PM
I'm looking for how others are performing a co
S3 Systems Administration
Changing the orgs email domain
7/12/2024 8:44 PM
Hello! We're changing our email
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3291
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1360
Roger French
1315
mark.cook
1244
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Financial Management
Lawson S3 Financials
APDISTRIB Entry/Create Date?
Please
login
to post a reply.
7 Replies
0
Subscribed to this topic
149 Subscribed to this forum
Sort:
Oldest First
Most Recent First
Author
Messages
Gary
Basic Member
Posts: 7
7/19/2010 2:22 PM
I'm trying to report AP transactions by the date they were actually entered. I'm not finding that date anywhere. There's an APINVOICE create date - not the same thing. There's a GLTRANS R_DATE which does not appear to be the correct thing and isn't useful for this report as it is not created until the transaction is posted. I figured it would be in the APAPDHIST file but I'm not finding it anywhere. If nothing else, isn't there a transaction history file somewhere that would have it? THANKS!!!
mark.cook
Veteran Member
Posts: 444
7/19/2010 2:48 PM
Gary, I am not sure I understand the comment about the Create date not being what you are looking for. That create date should be the date the invoice was entered. If that is not correct, what are you seeing as to what is wrong with it. I am using the create date for a couple smartnotes allowing the AP clerks to know what they have keyed during a given day.
Tom Keller
Advanced Member
Posts: 42
7/19/2010 2:55 PM
I agree with Gary, the create date on the APINVOICE table will give you the date the invoice was created. If you are looking for a specifice date stamp on when the distribution was entered, that might be different if you are reclassing invoices but the Create Date should give you what you are looking for. I don't k now of a specific date stamp on the APDISTRIB table.
Gary
Basic Member
Posts: 7
7/19/2010 5:45 PM
Tom - You got it. The date the invouce was created is not necesarily the same date that the distribution transactions are entered against it. You would think there's be a transaction history file with the user, date & time of each transaction but I'm coming up empty.
mark.cook
Veteran Member
Posts: 444
7/19/2010 6:32 PM
Gary,
I think the distribution transactions you are talking about are created with the AP175 Distribution posting. Unless you are creating, releasing/matching, and posting all on the same day these will differ. I am not sure the report you are looking to create but based on create date (date entered), distrib_date (posting date) along with the invoice date and due date are all the standard date fields.
The APAUDIT table would hold changes to vendor and invoice info but it does not store all invoice records.
Ruma Malhotra
Veteran Member
Posts: 412
7/19/2010 6:36 PM
AP175 posts the invoices and invoice lines to Gl and then GL190 posts all of this to the books. Really when AP175 runs is when the transactions are posted. You would not have a create date since you are not manually entering the transactions against GL but the distrib date in APDISTRIB is the date that the transactions are posted.
Tom Keller
Advanced Member
Posts: 42
7/19/2010 7:10 PM
If an invoice distribution is changed in the AP20.7 after the initial item is posted, it would have a different transaction date from the creation date. If the items are posted at different times they would also have different posting dates.
Gary, Maybe a solution would be to post AP everyday and then you could use the posting date as you transaction creation date.
Gary
Basic Member
Posts: 7
7/20/2010 11:39 AM
Everything that's been released is posted nightly by AP175 but there's an approval process that must be completed before the release. That might be same day or sometimes even a week or more.
Also, what Lawson calls a Posting Date is misleading. The APDISTRIB_DATE in the table is the date entered in Posting Date in the AP20 form, not the actual posting date. To get the actual date the transaction is posted, I've been selecting where APDISTRIB-REC_STATUS = 9 and pulling the GLTRANS-UPDATE_DATE. That is working well.
Please
login
to post a reply.