Replies posted by Dedi Tjong

34 Replies

RenukaDo Gooder

How to create supplier invoice and payment process, can you please help me to get step by step process for creating supplier invoice from start to end?

Hi Renuka, the basic supplier invoice steps involve this following, but there are a lot of other scenarios.Enter supplier id or name Enter the amount either gross or net depending on your setting. Move on to lower part of screen, enter the tax code that need to be charged to supplier move on the next detail the account number (what is the supplier invoice for). So pick one of the account. Enter the amount on one of the debit column, this amount should exclude tax amount. Once you see the balance field is zero, meaning (gross amount - tax amount) = debit amount, you can save the invoice. You can then post the invoice by RMB (depending of basic setup of the supplie rinvoice processing), some of them require you to go to ‘posting proposal’ screen to authorize the posting line.hope it helps.

2 years ago

Nagah.khaledHero

asked in Finance (Financials)

automatic payment process

Hi Nagah, the steps above you can see in the navigator windows, it is all ‘payment prposal’ under supplier payment. The first step on this screen is to load payment proposal, you can then select per supplier or other criteria. It needs to match the supplier payment method, although it used for bank transfer, you can also use this using CASH or CHK payment method, or even use other payment method. The purpose of this screen is to collect all invoices that due for payment. Once collected, the next steps is to acknowledge the payment proposal and create payment order. Once this is done you can acknowledge it from mixed payment.Try to go to navigator and look for payment proposal and try to load proposal, which is your first steps.Ensure that the supplier payment method matches your selection criteria.

2 years ago

Nagah.khaledHero

asked in Finance (Financials)

automatic payment process

Hi Nagah, for supplier payment, here are the major steps you need to go toCreate payment proposal, usually this is use against a certain payment method, for example SEPA payment where a file will be sent to bank to make the actual payment. After creating the proposal review the invoice being collected and you can edit/remove it. Once happy create payment order, this when the file is being created and send to the bank. The next step is to acknowledge the payment, you can do this in 2 ways, using payment acknowledgement or using mixed payment. if you are using mixed payment, select transaction type ‘Acknowledge supplier payment’ and then enter the payment order number. Someone has to approve this mixed payment.Hope it helps.

2 years ago

SwatiSidekick

asked in Finance (Financials)

changing accounting calender

Hi Swati, it is not possible to do from application. I suggest you to engage with partner or whoever knows how to manipulate the changes using sql script/back end as per Adam suggestion. This usually a chargeable activity. I suggest you do this quickly as January is coming soon. You don’t need to cancel the X voucher (PCA), During the data manipulation script, you move these PCA to the 1st day of your new period date, therefore it stays in same accounting period and it won’t affect your accounting balance / Trial balance.It is OK to change the voucher date as long as it is X, M or R vouchers since there is no other related transactions. But if you have other voucher type, you cannot.

2 years ago

cynthia.wilsonDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Use of External File Template

Hi Cynthia, you are correct, you can clear left over quantity from RNI by entering the close date to indicate no further invoice will be received in future and this is the correct process. Use external file transfer is fine to make the changes. as I can remember the close date doesn’t have any business logic link to it.It is safe to do it your way.

2 years ago

SMcLeesSidekick (Customer)

asked in Finance (Financials)

Customer/Supplier Invoice upload template

Hi there is template that you can use to generate a csv and you can use external supplier invoice function to read the invoice and process it, The external supplier invoice function derived from file template. This excel contain example and give you template to enter the supplier invoice. It also has some instructions on how to use the excel

2 years ago

Luiz RSidekick (Partner)

asked in Finance (Financials)

FA object import excel template

Hi, I believe you need to import it separately.

2 years ago

hazelmsSidekick (Customer)

asked in Finance (Financials)

Finvoice schema for EDI end-to-end mapping

Hi Hazel, thank you for reply. I do not immediately have this information unfortunately. I will ask around if there is any information I will post it here.

2 years ago

hazelmsSidekick (Customer)

asked in Finance (Financials)

Finvoice schema for EDI end-to-end mapping

You can usually get it from help or some article from the help / documentation.

2 years ago

SMcLeesSidekick (Customer)

asked in Finance (Financials)

Tax code - invoice entry

have you check the Supplier\Invoice\invoice \ tax info and if it has been defined.

2 years ago

SMcLeesSidekick (Customer)

asked in Finance (Financials)

Receipting POs - Static annual costs

You should be able to create preliminary supplier invoice and attach it to PO, you can then pay the preliminary supplier invoice. You can receive the PO each month and match it against the supplier invoice.

3 years ago

bytsophanHero (Partner)

asked in Finance (Financials)

Finacial postings from inventory transaction history

Hi, you can write below query in quick report. Basically you join the inventory transaction history (inventory_transaction_hist2) and the query posting (mpccom_accounting).You can put this in quick report.SELECT <include column you want here are some examples>ith.part_no, ith.contract COM, ITH.CONTRACT CON, MA.STR_CODE TRANS, ITH.TRANSACTION_CODE, ITH.source_ref1 OD, ITH.source_ref2 LN, ITH.source_ref3 RL, ITH.source_ref4 RC, MA.DATE_APPLIED DATED, DECODE(DIRECTION, '-', -QUANTITY, QUANTITY) * DECODE(MA.EVENT_CODE, 'RETREVAL+', 0, 'RETREVAL-',

3 years ago

ThejaSidekick (Partner)

asked in Finance (Financials)

External supplier invoice uploading error

If you search on navigator and search for external file screen, you can query your load id (this is not in supplier invoice), I believe it is in accounting rule section. You can open the load id and look at individual lines/records on how the system interpret your file contain and the exact error, thus pointing to you identify the cause.

2 years ago

SMcLeesSidekick (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

VAT Only Purchase Order

You can directly enter it through supplier invoice. it also possible to have zero amount invoice with VAT only.

3 years ago

Abid MujawarSidekick

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

need to extract excel format from ifs pdf file

In addition to Sachin suggestion by using sql query select * from <report_id> where result_key = <result_key>. You can use this query as quick report and replace the <result_key> with &result_key. This will allow a prompt to user to enter the report_id.You can find out the report id in ‘Report Archive’ screen.

3 years ago

tatansumrDo Gooder (Partner)

asked in Finance (Financials)

Opening Balance transfer through voucher type Q

Hi, just to add the period 0 balance is a result of year end of previous year.

3 years ago

MishaelAklekerSidekick (Partner)

asked in Finance (Financials)

Duty Charges on Imports

Hi, I like the detail of your question and it helps understanding the issue/topic being asked. In my opinion, it doesn’t seem to be that it is necessary to record the matching of PO against HMRC statement. Therefore all it matters in here is the amount to be reconciled.

3 years ago

SMcLeesSidekick (Customer)

asked in Finance (Financials)

Sending Customer invoices - Instant/Manual

Hi, unfortunately, I don’t have another answer.

3 years ago

SMcLeesSidekick (Customer)

asked in Finance (Financials)

Sending Customer invoices - Instant/Manual

Hi in Simple answer to a simple question yes, you need to check the permission set, the quick proof will be if you log in as IFSAPP and it works, it is definitely a permission issue.

3 years ago

SMcLeesSidekick (Customer)

asked in Finance (Financials)

Sending Customer invoices - Instant/Manual

Hi, it looks like you have permission issue

3 years ago

SMcLeesSidekick (Customer)

asked in Finance (Financials)

Sending Customer invoices - Instant/Manual

Hi Usually you can set this up under the customer/Address/contact section, you can enter customer contact with method e-mail. Ensuring the address has document address default tick.

3 years ago

JGHJILLDo Gooder (Customer)

asked in Finance (Financials)

Page 1 / 2

Replies posted by Dedi Tjong

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded