My Finance department is requesting a crystal report that reports actual and budgeted salary dollars for a given bi-weekly pay period broken down by Job Class. Has anyone done anything like this

If your attempting to complete a large change to your current allocation structure, this may be of some help to you. Please remember that the files attached are specific to my company. You will need to comb through your CA20, to see if there are fields that you are using that I may not be. You will also need to amend your columns to include the data that you will require on both the Query Wizard and the Upload Templete. I suggest you complete this upload in a test environment first, in ord...

Can someone tell me if there is a way to use a Lawson upload to do accounts payable invoice changes TA

I am looking into utilizing the Wells Fargo Payment Manager service pay our AP vendors in Lawson. The service accepts a single file with several different payment types such as check, ACH, P-Card via Mastercard gateway, etc. Wells Fargo processes the data file and pays each vendor according to the payment type specified. I support our Lawson system from a technical aspect. I'm trying to determine how to best pull the data from Lawson so that it can be manipulated into the Wells Fargo format...

Could I write a file/report off a library I am writing custom code in a library LPCUSTOMPD and would like to be able to write to a file. I am new to Lawson.

Does anyone know if there is a set of ERDs on the newest software version (or at least what has changed between the the current and latest versions) Were there a lot of changes

Hello. We are attempting to set up to process EDI 810’s in Lawson 9.0.1.5.768, using GHX. We have an issue regarding Trading Partner setups and how we configured our Vendor Locations in AP10.2. We have multiple facilities that have their own Trading Partner ISA ID’s. We have created a Vendor Location for each of our facility locations per each actual Vendor Location in order to have the proper account number in the AP10.2 form for each of our facilities. All of our Vendor Locations are set ...

Hello, I was wondering if there is a function/API that calculates the difference between two dates and returns a number I coded but I don't think it is calculating correctly. Any help would be greatly appeciated, thanks! Here is my code: MOVE LPC-PRM-THRU-PROC-DATE TO WSDR-FR-DATE. PERFORM 900-DATE-TO-JULIAN. MOVE WSDR-JULIAN-DAYS TO WS-SYS-JULDATE. *===CONVERT EMP ADJ HIRE DATE TO JULIAN DATE MOVE EMP-ADJ-HIRE...

In our ACTRANS table, there are many rows where the required key OBJ-ID has a value of 0, but other rows have a value that we can then link to the GLTRANS table. Why is this value sometimes 0, and what process updates it to a valid value Thanks -

Hi, I was wondering if anyone would be willing to share their Lawson training or navigational guides. We're going to be starting end user training in October and would like some ideas, etc. Thanks, D

I believe the ARITRANS table is a temporary table to interface records to (er, so I'm told). What the corresponding permanent table for ARITRANS after running the AR560 program There is a field called, AIT-USR-FLD-03, in ARITRANS that I'm curious where it gets mapped to after running the AR560. Is there any documentation, in general, where temp table fields get mapped to on permanent tables Thanks in advance, Doug

We use PO64.1 a lot to view activity on PO lines. We have been looking but cannot find a report that would print out this same information so we could dump it to excel. Does one exist We would like to be able to look at the PO Line Item History for all our open Capital PO's. (Note we do not have Add-Ins but I do use Crystal Reports). Thanks! Dave

Hi, I'm looking for inexpensive solutions or vendors for check printing solutions. We don't print that many checks per month and wanted to see if anyone has any good, yet inexpensive solutions, or use any 3rd party products, to print their checks. Any help is appreciated!!

We have existing pre-tax EE contribution 457 plans but now our company is offering a company match to some EEs. I've researched the PR05 and BN15 forms, user manuals, KB, etc. but the information on how to set the company match up seems piecemeal to me. I can't connect the dots yet. If anyone has a 'how-to' helper guide or form names and screenshots as to how you set it up, I'd be very grateful to see anything you might offer. For what it's worth, our company match is defin...

I am new to this, so please forgive me on this question, when users run ap520 there are no errors but a message appears that is saying comments not attached to invoices. Anyone have a clue to this Thanks for any help Frank

Recently GHX stopped sending us return email copies of the 810 invoice records. Being in contact with GHX, the email functionality has not been supported for some years, so it will not be reinstated. We've come to rely on the email copy to scan into our ImageNow application and tie to Lawson. Anyone have any suggestions on what they are doing Specifically to appease the auditors that like to see a 'pretty' version of the invoice, and not have to rely on reading an archived version of th...

I am trying to secure the data generated by GL298 so that the user sees only accounts/data related to a particular Process Level.Does anyone know which table(s) the rules should be written on Any other idea of a solution to this Thanks, Dennis

We use AC07.1 Account Assignment to restrict the company, accounting unit, account and subaccount combinations that are allowed to post to activities within an activity group. We would like to further restrict the current AC07.1 for one activity group currently as follows: Company Include 8800 8800 1 AU Include 6622827 6994827 1 Account Include 400000 899999 1 SubAcct Include 0 9999 1 Company Include 8800 8800 2 AU Include 9200837 9299847 2 Account Include 400000 899999 2 SubAcct Incl...

Hi, we have many one time vendors that we need to merge into permanent vendors. Normally we would run AP115, but this can only be run for a single vendor at a time. Is there an easy way to merge a large amount We have hundreds. Thanks! Cam

Hello, We are currently using fax integrator and it is stable and supported but we're wanting to upgrade to current version to position ourselves better for 10. Anyone with experiance upgrading to 9.0.1.1 please reply with time frame examples and any lessons learned they experianced. I searched for any patches to the Sept 2011 release and found none on KB. Thank you all in advance for your replies Cindy

I want to get Payment Proposals from suppliers into Lawson, which form should I be using Using Payment proposals suppliers request early settlements by agreeing to an offer and enables you to pay suppliers early in exchange for discounts

I need to add over 100 lines to an allocation. Rather than key everything in, I think it would be easier (and less risky) to create an upload Add In. Does anyone have an upload template they can share Does anyone know of a better way to add many lines to an allocation

Hi, We are looking for alternative ways to print checks w/o going with a 3rd party solution vendor, like MHC, etc. We only print a few AP checks per month (~200). Has anyone used a different approach/solution Has anyone used, or know of anyone, who uses Crystal Reports to format their checks out of Lawson Thank you, Doug

Has anyone had an issue in AM module where they've run an AM223 and the report is fine but when sent to CSV something throw it off so the excel sheet is unusable I've attached one....I think there may be a character throwing it off somewhere...but not sure.

Wouild like to hear from anyone who either knows how to reference in Lawson AR - or has developed their own SQL to be able to determine an AR Customers balance as at a point-in-time in the past. EX: Derive Customer Balance as per 5 days ago Any feedback/commentary would be most appreciated - thanks.