We are currently evaluating the AP300 for purging one-time vendors. Based on what we have tested so far, everything seems to be working great to purge these based on a cutoff date. However, we are going to want to purge our regular vendors in the future as well based on a cutoff date. However, from the documentation we've read, the AP300 defines a 'No Activity Vendor' as a vendor who doesn't have a balance in APVENBAL for the current or previous year (Lawson KB 81692). That sounds like it...

Hi all, I work in the government sector and it is very important that we retain a view to our committments/encumbrances at the end of a fiscal year as well as maintaining a view historically month to month. I just discovered GL192 which takes a snapshot of your encumbrances/commitments at year end prior to running GL197 (rolls encumbrances/commitments to the next fiscal year). While I understand that this takes a snapshot year end, is GL192 a process that should be run at every month end t...

We have a Service PO invoice that we entered prior to our upgrade to version 9.0.1 that needs a distribution change. When we try to change the coding in AP30.2, we get an error message 'Cannot add distribution, invoice is unmatched'. Prior to the upgrade our service invoices did not require matching. Does anyone know how to change these types of distributions. I can't find anything useful in the Knowledge Base. Worse case is we can do a journal entry, but we like to keep the AP invoice coding ch...

I need every employees start time and end time, to produce a daily productivity report. What time they are starting and ending. Labor productivity report. In which table the above information can be found. Thank you very much for the helpful info.

We are going to be collecting numerous of customers EFT setup data to support pre-authorized debit payments. Upon discussing with a Lawson Engineer - it was suggested: 1) At Conversion Time: Use AR501 (Customer Conversion) - uses staging table ARCCUST - this wil work nicely (and I've tested) - just include EFT setup data with the rest of the customer data conversion. 2) Post Go-Live: was suggested to use AR550 (Customer Interface) - uses staging table ARICST - I DO ...

We are seeing a large increase in our grants volume and would like others opinions on why it is better to use accounting units vs. activities or vica versa. More than likely we are not going to use Lawson Grant Module so that shouldn't be a constraint. Any thoughts are appreciated.

Good day everyone. I have my Income Statement in RW and it is working great, now we want to add some items to it at the bottomw to create a manager type of dashboard for a better term. I have our statistics loaded in the 9xxxx series so have IP Stat, OP Stat, ER Stat. On RW, I have these showing up great after the my income statement. Now I want to do a ratio of Total Revenue per Total Stat for each department that may have the information. This is where I am stuck. I created another...

We accidently ran AM195 (Year End Close) instead of AM190 (Month End Close) and in doing so we ran different AM190's and deleted the process. How can we reopen the year

We're currently trying to mockup creating an org hierarchy using attributes on accounting units. Our levels are all messed up in GLNAMES and we aren't going to be fixing that anytime soon. So my question is, can we somehow externally interface with mx10 to either create a manual or dynamic list Update that list I'm not seeing anything out of the box that allows such interaction. Am I missing anything

I moved this to the Add-Ins forum - that's where I intended to post it originally. But if you have an answer, feel free to let me know! --------------------------- We need to be able to add serial numbers to specific line items on an asset in AM20.3. Does anyone know how to do this with add-ins since the field name for serial is always row0 We have assets that can have up to 100 line items and each one needs its own serial number. I haven't tried it yet but the user did and was unsucc...

We have recently set up a new company. In our previous company setup if we try to process a PO invoice over budget it gives a 'Cost Budget Exceeded' error message. Activities set up under the new company are allowing invoices to post over the activity budget - Where are these parameters managed

I am posting invoices to the interface tables ARITRANS and ARIDISTRIB. How do I get to the process level and (revenue) account for a given customer

I just set up an Info Browser to get the current balance of one balance sheet account using the CYDAMT field. Why am I getting 10 different amounts The last one IS the current balance, which I need. I don't need to see the other 9. We are on Smart Office version 10.0.5.1

HI can anyone please let me know how to obtain the break up details for transaction present in Transaction Analysis(GL90.1). Thanks.

Our users would like to see vendor class displayed in the same area where vendor name and address now appear on the AP20.1 screen (basic invoice entry). This field was not available in design studio to simply be added - so I took a look at the PD and WS and .scr - as well as the APIN70 library PD & WS and added the vendor class fields and moves where I thought appropriate based on what seemed to be happening with vendor name. I still do not see the field appearing even after successful compi...

Good day all, I was not sure where to post this topic, so thought here. I have finanial ratios developed and have passed them to a subreport. I need to graph the ratio such as Total Margin now on a graph. In all of the google and reseach so far, the only way to do this in crystal is to send it to a subreport. I 'see' the shared variable now in the subreport, but can not get it to graph. I get an error message 'A print time formula that modifies variables is used in a chart or map detail'. ...

We are in the process of converting from LID to portal because of the upgrade to LSF9 security. One major function we seem to be losing is the copy/paste of data say from a GL95 inquiry. The create csv does not seem to adequately replace the copy/paste function. We are looking for any tips that would help us with this. Thank you.

Can cost centers be linked to another 'higher' cost center where each cost center allows posting, and when reports are run for the higher cost center it includes all data from the cost centers linked to it Or would a company have to have a different reporting grouping category and have an extra cost center that represents the higher level expenses In other words, can more than one level have posting capabilities

I am working on a project where I have most of the Lawson tables extracted and put into ACL(Audit tool). I have Invoice numbers for invoices that were paid in 2011 and 2012 after running APPAYMENT and APINVOICE. I need to know the line item detail of these invoices so I can see what the paid price was fro each item. I have aprox 2.3 mil line items associated with the PO numbers found in APINVOICE. I need to be able to join the POlines that have PO pricing to the actual price paid on the invoice ...

I am using Crystal and have used these two tables independently. Now i am joining the tables as the report I am writing needs both sets of information at the department level. Here is my problem: If an AU has both the amount accounts and the units accounts attached for example Salary accounts can have both amounts and units, I can get one or the other to pull correctly but not both when I play with joins. In the one report I have going, my salaried are tripple what they should be. I know it...

My healthcare organization is going live with Lawson in two days and I am looking for a comprehensive list of standard GL reports. Can anyone tell me where I can find this

Is there any difference in percent complete processing between AC165 and BR165 Reason I ask is I used both and nothing seems different in terms of how both update ACPERCCMPL and ACPERCCMPLX and BR130 seems to be updating revenue transactions correctly for contracts Percent Complete. How do I know which one to use Thanks.

I've found the account and accounting unit audit reports, but neither of these tell me who added an account at the AU level in GL20.2. Does anyone know how I can see who made accounts 'exist' for an AU

Hello,I am new to this and have only basic knowledge. Is there a way to retrieve invoices via M3 in electronic format e.g. pdf, csv, etc I know that I can get copy invoices via OIS680 but how do I get these into an electonic format Addins etc cannot be included Any help would be greatly received.Thank youclear

Hi, Has anyone done a custom interface that generates next invoice number via the BLOEL71PD module We attempted to use this module as suggested in the Lawson documentation, however, this module has multiple links that we cannot find causing compile errors due to undefined symbols. Please share the code if you did. Thanks