Replies posted by Thomas Peterson

743 Replies

Functionality regarding cash discount for purchase orders, asset accounting

Hi, If I understand correctly you book PO’s Invoices and similar to an interim account (X) that is not a fixed asset acquisition account. Then later create the FA object and move a value from X to your “true” acquisition account with the FA object using a manual voucher. The manual voucher in this case would no longer be directly connected to the invoice. The resulting payment term discount would no longer apply. IFS would need a more direct connection such as having the supplier invoice post to the FA acquisition account. This would bypass the interim account. Hope this helps, Best regards, Thomas

2 years ago

cperdueHero (Partner)

asked in Finance (Financials)

TransferError on External Voucher Upload

I agree with the above. See the external voucher basic data. Typically, I would have IFS assign the voucher numbers, leaving this off the template. Also, the voucher type would also not be in the template, as the load type would typically drive voucher type. If you need to reference an existing system / numbering process this data can be entered in the reference This is a common template I use for testing. For real life, add additional attributes, for example the code parts. In this simple example the amounts are all ± in column 3All records would have the same load group item (for example A). If the file should create two different vouchers the first group of records could have load group item A, the second group could be B. - For example assume your loading a payroll file that contains true payroll values in the first section (Group A), but then statistical data in the second section (Group B). Using the above template - My external voucher basic data is shown below. You can

2 years ago

Dennis MegaffinSidekick (Customer)

asked in Finance (Financials)

Dennis MegaffinSidekick (Customer)

asked in Finance (Financials)

Fixed Assets: Difference between Object group and Object class?

I believe the above reply from Adam is spot on. Very good reply.

2 years ago

Nagah.khaledHero

asked in Finance (Financials)

ORA-20110: ExtCheck.VOU_NOT_BAL: Voucher M1 is not balanced

Yep, as described, if all records have the same load group item only 1 voucher will be created. That’s the intent of load group item. But if you need different vouchers from the same file, then you would have different groups and the data must balance within a group.

2 years ago

RcoubrouHero (Customer)

asked in Finance (Financials)

Cancel Manual Voucher / External Voucher

Hi, An external voucher once in voucher entry can’t be canceled or deleted or edited. The posting rows would be similar to other system generated values and you can’t edit or delete. If you see the posting lines they are marked as External - can’t change these. You can make a copy of the voucher as a reversing entry. I believe the easiest way is update to GL and then copy GL Voucher like you did previously. Another option is to use the copy voucher in hold table. The results are nearly the same. The voucher must go to GL at this point. The IFS expectation is that the external voucher would have been reviewed in the external voucher process. After we (the client) is fully familiar with external voucher and the data flowing into external voucher - we automate the check and create. After this point in understanding / knowing the data, the need for rollback is minimal. Hope this helps, Best regards, Thomas

2 years ago

yoderkdDo Gooder (Customer)

asked in Finance (Financials)

Multi-Company External Voucher Template

Hi, As far as I know, IFS has not created the intercompany due to / due from for external vouchers. When the functionality was released it was tested and noted that limitation. It was added to a wish list. You can easily use external voucher - make a copy of the STD VOU template add company ID to the template. Also make sure the external voucher basic data is set up in all companies listed in your external voucher file. The external file data must balance per company. - IFS does not create the due to / due from in this process. - I Best regards, Thomas

2 years ago

NayLanLaDDo Gooder (Partner)

asked in Finance (Financials)

Sum function to total payment_amount in external payment file (BACS)

The alternative to what you have previously done is to use LUMP_SUM_PER_ORDER as the basis for your file.

2 years ago

RakeshSidekick (Partner)

asked in Finance (Financials)

Currency Rate Updation in PO

Typically, the accounting currency rate is driven by Finance, meaning its not something a receiving person would enter. Provided the rates are updated periodically the arrival transaction will have the “appropriate” rate from a finance perspective. Some clients update the rates daily, others update less frequency. Then when you process the supplier invoice you can enter a revised rate or use the defaulted rate. Then at payment (depending on payment method) we can enter the final rate at time of payment.

2 years ago

RakeshSidekick (Partner)

asked in Finance (Financials)

Currency Rate Updation in PO

Yes - Provided the currency code is different from the accounting currency (my company is USD the invoice was CAD) you can enter nearly anything in the rate. As shown below. Note the 854 rate was just an example USD / CAD is closer to 1.25.

2 years ago

VsoMdsaiIDo Gooder (Partner)

asked in Finance (Financials)

Mixed Payment Bulk Upload

Hi, I know this is not the answer your looking for… but … In older IFS releases, I have previously created a header record in mixed payment and then created an external file to load the transaction lines. It was not elegant, but worked. Also, I have created files that flow through external payment. The external payment then creates the mixed payment. I see a number of file templates with file type ExtMixedPayment in apps 10. I have not tested, but theoretically, you should be able to copy one of those templates and create your own. These templates have header and detail records. Looks like that “should” work. Best regards, Thomas

2 years ago

XitThejaGSidekick (Partner)

asked in Finance (Financials)

Supplier off-set

I guess the question would be -- why so many SUPOA’s. Typically these would be automatically included in the automatic payment process. In doing this you would normally include these when paying the supplier - automatically offsetting these open items with the invoice. Check your settings in the company / payment set up. In the offset screen you can select batch and select many items. Sure it needs to balance, but you could balance by changing the amounts on the largest items. Normally I would prefer the above, as when doing this the remittance data can be sent to the supplier so they see what your doing. If you use the offset, IFS does not “automatically” send this information to the supplier.

2 years ago

ATarBPTSidekick (Partner)

asked in Finance (Financials)

Error with PO/Invoice Matching for Inventory Part

I see the setting is to match at PO receipt. When doing this IFS is expecting a receipt reference (usually packing slip / similar). Did you enter this data when entering the supplier invoice? Did you confirm that this value was exactly the same as the receiving transaction? Typically matching at receipt reference can be tough as the invoice may not include that same reference number or the receiving staff can enter the wrong id. Sure, receipt reference is appropriate at times, but header matching is more common much of the time.

2 years ago

Thom CHero

asked in Finance (Financials)

Charging a Cost Center in Company "A" for a PO paid in Company "B"

Hi, If this is a routine - we routinely move cost from company A to company B, we may be able to automate. If we hit a given account string, we can allocate that account string balance (at month end) 75% Company A and 25% Company B, using “Multi Company Allocation”. If this is transaction X that needs to be be moved or split from company A to B, then that not as easy.. You could probably create a routine triggered by a user, that would “automagically” create a multi company voucher. But then who approves the charge flowing from company A to Company B? It could be better if this is transaction by transaction by transaction to ad posting lines to the supplier invoice. In this the posting lines would then flow through an authorization process assuming your using supplier invoice workflow.

2 years ago

Nagah.khaledHero

asked in Finance (Financials)

IP28 control type is missing in posting control

Hi, I would recommend logging into a test data base, enter posting control IP28 (create a new record and type in IP28) with a fixed value control type. The account string should probably be the same as GP1. Then test the exact same entry again. If IP28 is triggered, we would hope this to be a very small amount. If you need to test in PROD, you can do same as above but verify that the IP28 should have the same string as GP1. The difference value should be small. Best regards, Thomas

2 years ago

mabrplSidekick

asked in Finance (Financials)

IFS10 Project Revenue Recognition ( POC) issue with Inventory and WIP ( Balance Account)

Hi, In apps 10, IFS added the option on balance sheet accounts such that these accounts would be considered as a cost in the rev rec process. The intent is that inventory and WIP would values would be seen / considered as cost when running rev rec. For example assume 500 in true cost accounts, and 1000 in inventory as an asset, If you check the box on your inventory account, IFS rev rec would calculate 1500 in cost, giving a far better (more accurate) POC when using actual cost as the PO driver. You only want certain accounts to have the box checked. For example if both sides of a PO arrival (both accounts) have the box checked then you have no real effect. +100, -100 = 0. Only check the box on the desired account(s) such as inventory and WIP. Best regards, Thomas

2 years ago

RcoubrouHero (Customer)

asked in Finance (Financials)

Charging Interest on Customer Interest

Hi, Interest Invoicing is really easy. Update (or create new is probably better) the interest template such that will calculate interest as intended. Make sure that template is on the customer. Assuming you’re in TEST (and always test in TEST), enter a large value instant invoice with a very old date. (old enough such that it will calculate interest). Then run the interest invoice proposal. You will see a selected customer, and then see the related interest calculation. If you created a “new” interest template be aware the old invoices are connected to the old template. Usually we have different templates for good customers / bad customers with different rates. For the old invoices you can reassign the old invoices to a revised template. The process is pretty easy. Just remember when an invoice is created the template assigned to the customer is then assigned to the invoice. If the default template is set to “not” charge interest, then you may not get interest on those old

2 years ago

Nagah.khaledHero

asked in Finance (Financials)

IP28 control type is missing in posting control

GP1 is a rarely used posting type. But I’ve never not set it up. GP1 is a rounding difference type posting just like IP28. Please copy the IP28 to all companies. Usually as best practice we try and keep all companies set up the same. It’s far easier if every company is set up the same. Use the copy to companies option.

2 years ago

KLAVALLEYSidekick (Customer)

asked in Finance (Financials)

Customer Agreement Description field not available to Customer Agreement Report

Hi, This should probably be in the distribution group. It’s considered part of customer order / pricing functionality.

2 years ago

bytsophanHero (Partner)

asked in Finance (Financials)

cannot create the invoice from the external supplier invoice

Hi, If the invoice is in external supplier invoice you then should be able to drill down to the invoice details. You may need to drill down multiple levels but you want to get to the postings screen. This would note an account number used in the posting. Check that account. I would check that first. Best regards, Thomas

2 years ago

bytsophanHero (Partner)

asked in Finance (Financials)

cannot create the invoice from the external supplier invoice

Hi, This is where you want to end up. See if the account has a description. If it does not, then that account is missing in that company.

2 years ago

RcoubrouHero (Customer)

asked in Finance (Financials)

Charging Interest on Customer Interest

OK my bad. You want to calculate interest on existing interest invoice (I believe). Yep that’s not as easy. Honestly, I’ve never come across that requirement, My clients are mainly in US but most have sites around the world. I did a quick test and your very correct the IR is not picked up for interest on interest. Did not see any settings that would do that. Still looking. I do remember some “local” requirements - don’t remember if that was Brazil or India / reading something about this. What version are you using?

2 years ago

Page 1 / 30

Replies posted by Thomas Peterson

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded