web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Processing purchase in...
Microsoft Dynamics NAV (Archived)

Processing purchase invoices without purchase orders

(0) ShareShare
ReportReport
Posted on by Community Member

Hi

I am new to Nav 2009 started with my employer 2 weeks ago and I have a few questions around purchase invoices, I'm hoping you can help me. Sorry for all the questions but all I have is the course guides left by my predecessor, who left before I started so no hand over and everyone else in the team is new. 

  1. Is there a way to be able to view the name of the vendor on a general ledger extract in excel for purchase invoices?  Wondering if it is possible to set the vendor code up as a dimension on the input template might achieve this (if it is even possible)?
  2. The description that is appearing in the general ledger is the PI number generated within the system.  I'd like a more useful description such as for example with a rent invoice the date range we are being charged for is there a way of changing this please, as its defaulting to this when entering invoices?
  3. Can purchase invoices be loaded into Nav 2009 as a batch import using excel?

Any help and advise is really appreciated.

 

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    keoma Profile Picture
    keoma 32,729 on at

    ad 1:

    edit page 20

    add variables

    VendorName, type Text

    PurchInvoice, type rec, subtype "purch. inv. header"

    Vendor, type rec, subtype vendor

    add following code to trigger OnAfterGetRecord()

    IF "Document Type" = "Document Type"::Invoice THEN BEGIN

     PurchInvoice.GET("Document No.");

     Vendor.GET(PurchInvoice."Buy-from Vendor No.");

     VendorName := Vendor.Name;

    END ELSE

     VendorName := '';

    add new field in page, source = VendorName

    alternativly you can add a new field VendorName in table 17 "G/L Entry" using flowfield functionality.

    ad 2:

    add a new field "description 2" in page 20. add needed code also to trigger OnAfterGetRecord, set there the value of the new field as combination of the needed info. do not change field description.

    ad 3:

    use migration tool or create dataport or a xmlport to import the invoices.

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 on at

    #1

    When you post the purchase invoice, in GL entries there is a field Source No. that is filled with a supplier code. You can put this field on the page to view it in GL entries. It would not give you directly the customer name, but at least allow you to manipulate it further in Excel and add names there using simple Excel routines.

    If you want permanently see the supplier name in the GL Entry table, you can add a field and call it "Supplier Name" to GL Entry table, than make it a FlowField and relate it to Vendor table by Source No. field. Note that the Source No. field can also be filed with other types of data (customer code, fixed asset code, etc.), so you should use different additional fields for different descriptions. And, always consider the database performance - too many flowfields might reduce the performance of the database.

    #2

    The description in the header actually affects what would appear in the GL Entry. If you will manually change the description in the header before posting, it will appear in GL Entry when you post it.

    If there is an automated algorithm that allows the system to calculate the description (e.g., if system can calculate rent invoice date range from e.g. posting date), then it can be automated by adding small line of code to the page by trigger (do not modify the posting code, it is not needed!).

    #3

    There are lot of options. Rapidstart might help.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans