Small and medium business | Business Central, N...

Capturing Dates

(0) Share

Report

Posted on by aryaps

151

Hello All,

here we are facing an issue in capturing the dates, for an item while purchasing we will get the warranty from the vendor, and same while we selling the item we need to give the warranty to our customers. with the help of item tracking we can enter the warranty details while purchasing or receiving the goods. While selling how do we give the warranty dates

We need to capture 2 dates. one is while receiving the item from vendor on Good Receipt Note , 2nd we need to enter the warranty details in each line item while selling the product.

Kiindly help me on this.

All responses (9)

Answers (0)

Suggested answer

Govinda Kumar 2,203 Super User 2024 Season 1 on at

Like (0)

Report

RE: Capturing Dates

Hi aryaps,

Yes, if you want that field to show up in a bunch of different places like item tracking lines, sales line, sale inv, posted sales inv, item ledger, and job journal etc, you need add the same field with the same ID in all those places. Nitin Verma already said that.

But like, for Job journal and Item Ledger entries, it's a bit different. You have to figure out the right event to use for transferring the values to the ledger tables. If you let me know which code unit or process you're working with, I can help you figure it out.

Regards
aryaps 151 on at

Like (0)

Report

RE: Capturing Dates

okay i got it, i have one doubt. if we add a same field in item tracking lines, is it come in all places, without adding each page.
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: Capturing Dates

Hi,

You are not following what has been answered, all your field's values will be automatics transferred to posted tables if defined with same id in all the tables.
aryaps 151 on at

Like (0)

Report

RE: Capturing Dates

extending all the table and pages is the only way?

how the value will be transferred from the sale order to inv, inv to posted etc...

how do we transfer the line details to job and item ledger too
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: Capturing Dates

You have to extent the table for same field with same id in Sales Invoice Line, Sales Cr. Memo Line, Sales line Archive, Sales Shipment Line, and you have to create that field on Item Journal Line, Item Ledger Entry, Job Journal Line, Job Ledger Entry table as well.

And for Job and Item Ledger you have to subscribe the events then it will be transferred.
aryaps 151 on at

Like (0)

Report
RE: Capturing Dates

How can we bring the same into all the sales transaction and job journal field and item ledger entry also.

yzhums Nitin Verma Mohana Yadav . Could you pls help me on this

tableextension 60106 "Warranty Date on SalesLine" extends "Sales Line" { fields { field(60106; "EPM Warranty Exp Date"; Date) { DataClassification = CustomerContent; Caption = 'EPM Warranty Exp Date'; } } } pageextension 60204 "Warranty Details on Sales" extends "Sales Order Subform" { layout { addafter("Quantity Invoiced") { field("EPM Warranty Exp Date"; Rec."EPM Warranty Exp Date") { ApplicationArea = All; Caption = 'Epm Warranty Exp Date'; } } } }
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: Capturing Dates

Hi,

If you create any fields on Sales header or Sales Line table and same id field to sales posting tables, it will be automatically transferred to posted one without any code.

But yes if you want to transfer that field's value to Job Ledger entry or Item ledger entry you can subscribe the events.
aryaps 151 on at

Like (0)

Report

RE: Capturing Dates

add a field is not an issue. my doubt is if we add a field in sales line, does it comes in all sales lines (Sales order, sales invoice , posted sales inv..etc).

it should come all sales transactions and Job journal also. in that case what should i do?

if enter the values how it should transfer from sales order to inv, inv to posted sales, job journal and Item ledger entries also etc and all
Suggested answer

Shathika Karunaratne 410 on at

Like (0)

Report

RE: Capturing Dates

Simply add two customized fields to Purchase Line and Sales Line. Therefore, you can manually enter dates when posting GRN and selling. This needs a help of a developer.

Hope you find it useful.

Thank You

www.linkedin.com/.../