I need help for n8n workflow.I hve creating 3 way order procurement workflow

Questions
1

I am getting configuration issue while setting, Can anyone please provide support for n8n order procurement 3 way match

2

Hey @Bharat_Varshney !

Can you be more specific? Or share an image, workflow or at last the errors you encountered so far.

Cheers!

3

can I share json

4

If you click the </> button when you write your post, there is the place where you can attach your json. CTRL+A select your nodes in workflow, CTRL+C copy them, and CTRL+V paste that in the section of the </> after you click.

5

getting error json is too large and not supported above character

6

Please help

7

Please upload your json to a google drive and share link. Also share more information of exactly what your use case is, what are you trying to achieve, etc

1 Like
8

here is the link https://drive.google.com/file/d/1hVueMu4kNQIEUcBvywaknrL5LiYp6TWV/view?usp=sharing and use case is this -A requester fills out a form with details about what they need to buy (item, cost, supplier, etc.).

The workflow checks if approval is needed. If the amount is high or certain rules apply, it sends a request to a manager. Low-cost requests can be auto-approved.

Once approved, the system automatically generates a purchase order (PO) number and records the order details.

When goods are delivered, the receiver marks them as ‘received’ in the system, confirming the PO.

A supplier can submit an invoice using another simple form, which is linked to the PO and the delivery info.

The workflow checks all three: PO, receipt, and invoice—this is called “three-way matching.” If everything matches (amount, items, supplier),

The invoice is approved and marked for payment. If something doesn’t match, the system flags it for review.

9

I have tried its failing and main reason I am very new in n8n

10

Thanks for sharing the workflow, I now have a much better view. From what I understand is that this process might happen over a period of time and the final matching only once all 3 items are present, PO, receipt and invoice. This suggests to me that it is just a logical thing you have to build and is totally possible in n8n. You’ll just need to create separate Workflows for each stage of receiving things. Im happy to jump onto a call sometime to walk you through a possible solution as you’ll probably need to incorporate a database of some sort to keep track of a single order over time. This forum might be difficult to explain.

But in short, the workflow you shared takes the order and generates the PO. You’ll need another webhook in either the same workflow or a separate one to receive the receipt details of the order and update your data source, whether data-tables, google sheet or a proper db.

You will then have a 3rd workflow which will have the invoice part and the logic to do the “three-way matching” logic based on the 3 items now stored in the db. This either happens on the last step that came in or it could simply be a scheduler which runs every hour and processes your records. It’s neither here nor there, just depends on how you want to architect the overall solution.

1 Like
11

Please provide support

12

how to connect you can you share your mail id to schedule call

13

@Wouter_Nigrini can you please help

14

the first thing that is wrong with your code is using

const poData = $input.item.json;

you are using code node and its mode is Run Once For All Items, so you must use

const poData = $input.first().json;
15

After that my execution will work @ramin1 Can you please quick help

16

@Bharat_Varshney

I just mentioned the first error in your 3 way code node. i didn’t debug all of it, but if you send me the workflow with pinned data, i will debug it for you. if you don’t want to share your pinned data publicly, feel free to DM me

17

Hi @Parintele_Damaskin I already share my json in this group .Could you please check workflow properly not working

18

Hey @Bharat_Varshney !

Checked your file, and it seems you have all you need, but in a way that you clearly don’t understand.

As @Wouter_Nigrini already mentioned, you need to split that workflow in 3 workflows, since there are 3 main Webhooks that listens for different information.

And thus Webhooks needs and interface UI to interact witht that triggers. 1st can be a form or even a chat trigger node if you cannot build an UI, there it seems in the logic that in some case a human is needed, you need to save the data somewhere as well… etc

There’s no “plug and play “ answer solution for your case here, clearly you need to understand n8n(even basic skills), and then if you encounter an issue, you can ask here for help.

P.S what are you asking here is more a job or a consultant opinion (which here sometimes you get it for free).

Cheers!

1 Like
19

Thanks you for reply but I have created 3 workflow but right now facing challenges in the configuration

here is the link for all configuration -https://drive.google.com/file/d/1SY6LWB05_x-ELDk_GsKLQN4cF_ILktPa/view?usp=sharing @Parintele_Damaskin @Wouter_Nigrini

20

@Bharat_Varshney did you find a solution yet?