Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Cory Severson]

Up

0

Down

::

Hello,

As you know, those windows do not have options for user defined fields. If you can repurpose an existing field, I would recommend that. If that doesn’t work, then you can look at third party products like Extender. Otherwise, you’d need to look at custom development.

Take Care!

Cory Severson

Velosio

[that canadianguy]

Up

0

Down

::

Thanks Corry for you reply

im good at SQL i can change tables schema but not sure if this will impact future updates

[Jo deRuiter]

Up

0

Down

::

Hi Canadian Guy,

There are already fields for these ID’s.

In Purchasing the Document Number is the Vendor’s Invoice Number and the Voucher Number is YOUR key field for that purchasing document – you should rarely be changing the Voucher Number unless you were specifically asked to.

In Sales, the Invoice Number is YOUR invoice number to the customer and is 100% unique. The PO Number field in Sales (whether Receivables or Sales) is good for Customers PO Number, which is generally what you are getting from a Customer)

If you are trying to use a separate source-systems invoice information, if it is done right, you can use those source-system numbers as your sales-invoice numbers already – you can use it in the integration to replace the default invoice numbers in GP.

Otherwise, let me advise against a developer just for User Defined (UDF) Fields in GP – the best product there is for this is eOne’s Extender and you can create tons of custom fields and report on those as well.

[that canadianguy]

Up

0

Down

::

Thanks Jo for your explantations

ill check that , is it bad if we create customs fields by changing tables schema ?

[Beat Bucher]

Up

0

Down

::

Hey “That CanadianGuy”…

As Jo stated, it’s a very bad idea to change the GP table schema and field definitions.. at every next upgrade you run the risk to scrap your customizations as the table might get recreated in the process of upgrading.

Another alternative to use the eOne Extender product is GP PowerTools and the developer module.. With modifier you can add new fields into existing forms and populate the data with a code logic in GPPT. I agree that it requires more programing skills than using Extender, which is also easier to query data from later on.