FI invoice processing

[#1]

Hi,

I have few queries related to Consolidated Invoice Processing (FI Invoices).

Normally we receive Invoices/Statements from Vendors (Bank,Car,Fuel,Mobile,Fixed Lines) on monthly/weekly basis.

The charges in the invoices/statements need to be allocated to respective person's account (WBS or CC).

The payables team park's the invoice/statement by using T-Code FB60 & i send codes (GLCode,CC,WBS,PC) to post the invoices.

This is simple if the invoice has only few lines to code,however if we receive 1000+ lines we are spending more time in closing the invoice. (i.e) we need find all the WBS & CC which is allocated.Here if we receive 1000+ lines 1 or 2 line code is sent to payables team to post the parked invoice & we post journal to match it depending upon the entity we work.

Is there any T-Code other than FB60 to post multiple lines (1000+) in one shot,as FB60 allows 10 lines to enter the details & we need to scroll down to enter another 10 lines which is not easy for all the invoices.

Please let me know any other simple ways to process these kind of invoices.

Also advise the T-Codes relating to posting the FI invoices.

Thanks & Regards,

Sebastian.N.J

[former_member205762]

Hi you can not post more than 999 with standard functuionality

For that you need to create Custom Program.

Thanks

Manoj

[Former Member]

You need a custom invoice upload program to handle this. SAP allows a maximum of 999 line items on a given document. Work with a developer to create a z-tcode that will make postings into FB60 in the back-end + which enables uploading invoice through a file + which enables posting more than 999 lines in one go. For posting with more than 999 line items, you will need a GL clearing account which will debit/credit the first invoice and offset the balance in the next invoice and so on, until the final invoice is posted. The next invoices will have a slightly modified reference number (say, adding an A at the end, then B & so on). Hope this helps.

Regards,

MG

[sanilbhandari]

Hi

I think you can use F-43 to post such an entry using the Fast Data Entry screen for such invoices.

When you click on Fast Data Screen, a new screen will open up where you can enter the line item details.

You can set the display for this line item through config change on what columns should be displayed, may be WBS in your case. One you reach last item, press enter to see the next screen

If the volume is quite high, you may also look at developing an upload tool using a custom code for the same.

Thanks & Regards

Sanil Bhandari

[Former Member]

Hi,

Thanks for your reply.

Let me know how  do i insert the WBS & text column for each line item.

Also how to enter cross CC when i tried to do it i received a error message as

Select another number, 0584 is already assigned

Thanks,

Sebastian

[sanilbhandari]

Hi

You can use O7E6 to configure the variant for fast data screen. You cannot have more than 999 lines items in a single accounting document in SAP, whether through a custom program or through standard program. You will have to break it up in seperate journals, if the document is coming in from FI Application which is the case for you.

Regards

Sanil Bhandari